%let YEAR = 2013; %let MON = Jun; * CHANGE AS NEEDED *********************; **********************************************************; * Program: SUS_WebPubPgm_SAScode.txt *; * All Rights Reserved. Software User Services. *; * Mequon, Wisconsin, USA *; * Mailing *; * Address: PO Box 96, Milwaukee, WI 53201-0096, USA *; * History: First developed in 2005 to support the *; * Wisconsin Illinois SAS Users Conference. *; * Revised yearly for conferences. *; * Latest Revision Date: 25 June 2013 *; * Purpose: Provide a web table of contents and links *; * to ANY collection of electronic resoources, *; * but designed by default for specific items *; * that it assumes have been pre-loaded into *; * pre-allocated folders. *; * Note000: This SAS program expects the macros *; * that it uses to have been stored *; * in the location designated below *; * on the statement %let MacroFolder = *; * Note00: The HTML code for web pages that it creates *; * expects two GIF files to have been stored *; * in the folder SUSXXYYYY\Images *; * where XX is the appropriate month, and *; * where YYYY is the appropriate year. *; * Note0: This SAS program contains commented out code *; * that could be used to provide *; * a link to local SAS resources at your site. *; * Note0: This SAS program contains commented out code *; * that could be used to provide *; * a link to local SAS resources at your site. *; * Note1: This SAS program is distributed *; * with companion macros used by it, and *; * with the designed-in folders of resources. *; * Those designed-in folders can be ignored, *; * but then all links to them must be deleted *; * from this program. *; * Regardless of what is done *; * with the designed-in folders and their links, *; * new folders can be added, and links to them. *; * Note2: The %CreateCustomStyle macro used here can be *; * invoked with other assignments if you want *; * to change the appearance of the web pages. *; * The parameters assigned here are the same as *; * the macro defaults. *; * Note3: The %CreateCustomStyle macro must have been *; * pre-loaded into &MacroFolder as assigned. *; * Note4: Use of the %CreateCustomStyle macro is *; * NOT mandatory, but if not used, you must *; * revise your use of the %HiddenFakeTable macro *; * as appropriate. *; * Note5: %WebPubStdFootNote & %HiddenFakeTable macros *; * used here must ALSO have been pre-loaded. *; * Note6: The WebPageBackgroundRGBcolor assigned with *; * the %HiddenFakeTable macro MUST MATCH the *; * WebPageBackgroundRGBcolor assigned with the *; * %CreateCustomODSstyle macro. If you do not *; * use the %CreateCustomODSstyle macro, then you *; * must determine the web page background of the *; * ODS style that you are using, and MATCH it. *; **********************************************************; %let path = C:\SUS&MON.&YEAR.; * Adjust above storage location for web pages as appropriate *; * Any folders referenced by Path or elsewhere below must be pre-built & loaded *; %let MacroFolder = %str(&Path.\Proceedings\SUSmacros); options sasautos=(sasautos "&MacroFolder") mautosource; %let WebPageBackground = CXFFFF99; * light (not lightest) Browser-Safe yellow *; * lightest yellow may wash out on an LED screen *; * This color is used by %CreateCustomODSstyle and by %HiddenFakeTable *; %let LargeFontSize = 16pt; options mprint; /* show code generated by macro, and executed */ %CreateCustomODSstyle (CustomStyle=LeRBrecommended, WebPageBackgroundRGBcolor=&WebPageBackground, TableTitleFootnoteFont=Georgia, TableTitleFootnoteSize=4, TableHeadingFont=Georgia, TableHeadingSize=1, TableDataFont=Verdana, TableDataSize=1, TableFrame=void, /* use TableFrame=void to remove frame */ TableFrameRGBcolor=CX9999FF, /* light (not lightest) Browser-Safe blue */ TableGrid=NO, /* use YES to turn on grid between data cells */ TableSpacing=0); /* the SAS-shipped default is 7, space between cell data and cell boundary */ ods noresults; ods listing close; ods html path="&Path" (url=none) body='StartHere.html' (title='SAS Papers, Slides, Documentation, Tools, Linked Resources') /* title appears in blue bar at top of this web page */ style=styles.LeRBrecommended; * style=styles.Minimal; /* this one is SAS-provided, its web page background is white */ title1 j=L c=CX000000 h=&LargeFontSize "Welcome to the &MON &YEAR Software User Services Collection of SASŪ Papers, Slides, & Code," j=L 'and to This Portal to Linked Resources for Users of SAS Software'; title2 /* ************************************************** If you want to provide links to local resources, * UnComment the code below, and * create the needed target HTML file. */ /* ******************************************************************** j=L ' ' j=L c=CX0000FF 'Local Resources:' j=L link='UntilYouDoSomethingThisWillNotBeFound.html' 'Web Page for Local SAS Resources, to be constructed at the user site' c=CXFF0000 ' (last updated on dd MonthName 20??)' ******************************************************************** */ /* In the html file linked to above, * provide link(s) to your site's resources. * **********************************************/ j=L ' ' j=L c=CX000000 link='bios.html' 'About the Speakers, Other Contributing Authors, and the Volunteers' j=L link='slides.html' 'Conference Slides' j=L link='papers.html' 'Conference Papers' j=L link='programs.html' 'Sample SAS Programs' j=L ' ' j=L c=CX000000 'Resources at SAS Institute and Elsewhere:' j=L link='sasHelp.html' 'Ways/Places To Get SAS Institute Help and Information' j=L link='RemoteTips&News&Links.html' 'SAS Information at Other Remote Sources' j=L link='http:\\www.wiilsu.org' "Wisconsin Illinois SAS Users Home Page" j=L ' ' j=L "We thank SAS, Experis, the MidWest SAS Users Group, the Texas A&M Online Statistics Program, and Executive Recruiting Resources LLC" j=L "for their essential support for the conference." ; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); *HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); %HomePageAnimationAndFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); ods html path="&Path" (url=none) body='sasHelp.html' (title='Ways/Places To Get SAS Institute Help and Information') style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize 'Ways/Places To Get SAS Institute Help and Information'; title2 j=L ' ' j=L 'For SAS Products & Solutions, User Success Stories, etc., see: ' link='http://www.sas.com' 'SAS Home Page' j=L ' ' j=L 'For the SAS knowledge base (online manuals and tons of technical information),' j=L 'training & publications, and SAS-hosted discussion forums, see: ' link='http://support.sas.com/index.html' 'Online SAS Customer Support' j=L ' ' j=L 'If you have a SAS software problem, talk to an in-house SAS expert or your Help Desk, or:' j=L link='http://support.sas.com/ctx/supportform/index.jsp' 'Web Submit the Problem to SAS Technical Support' j=L 'or get SAS Technical Support via telephone: 1 919 677 8008' j=L ' ' j=L c=CXFF0000 'SAS Technical Support will also answer How To questions.' c=CX000000 j=L ' ' j=L 'When using SAS Technical Support (via Web Submit or Telephone), you must supply' j=L "SAS Site Number, " "SAS Software Version, " "and SAS Computer Operating System" /* "SAS Site Number: &SYSSITE, " "SAS Software Version: &SYSVER, and " "SAS Computer Operating System: &SYSSCPL"; */ /* NOTE: When you run this code, if you substitute the three commented-out lines above for the corresponding three un-commented-out lines above them, then SAS will replace the &SYS macro variables with values that describe the computer on which the code is run. */ j=L ' ' j=L link='http://support.sas.com/techsup/trackintro.html' 'You can check the status of a problem or question that you have submitted to SAS Technical Support' j=L 'Response to a Web Submit will be 24 hours or less. A phone call might get an immediate solution or answer.' j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); %HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); ods html path="&Path" (url=none) body='RemoteTips&News&Links.html' (title='SAS Information at Other Remote Sources') style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize 'SAS Information at Other Remote Sources'; title2 j=L ' ' j=L link='http://www.views-uk.org' '"VIEWS, the International SAS Programmer Community": Home Page, How To Join, etc.' j=L link='http://www.views-uk.demon.co.uk/Newsletter/backcopy.htm' 'To download back-issues of the VIEWS newsletter' j=L ' ' j=L link='http://www.lexjansen.com' 'Explore Lex Jansen''s Links to a Treasure Trove of SAS Lore' j=L ' ' j=L link='http://www.sasCommunity.org' 'Wiki-based SAS Users Information Exchange Environment' j=L ' ' j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); %HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); ods html path="&Path" (url=none) body='bios.html' (title='About the Speakers, Authors, and Volunteers') style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize 'About the Speakers, Authors, and Volunteers' j=L 'In Alphabetical Order'; title2 j=L ' ' j=L link='Proceedings\Bios\LeRoyBessler.pdf' 'LeRoy Bessler (Volunteer & Author)' j=L link='Proceedings\Bios\DavidBruckner.pdf' 'David Bruckner (Volunteer)' j=L link='Proceedings\Bios\DavidDickey.pdf' 'David Dickey' j=L link='Proceedings\Bios\JoshHorstman.pdf' 'Josh Horstman' j=L link='Proceedings\Bios\GeorgeHurley.pdf' 'George Hurley' j=L link='Proceedings\Bios\MistyJohnson.pdf' 'Misty Johnson' j=L link='Proceedings\Bios\LauraMacBride.pdf' 'Laura MacBride (Volunteer)' j=L link='Proceedings\Bios\JoeMorrissey.pdf' 'Joe Morrissey' j=L link='Proceedings\Bios\RogerMuller.pdf' 'Roger Muller' j=L link='Proceedings\Bios\AlexandraRiley.pdf' 'Alexandra Riley (Volunteer)' j=L link='Proceedings\Bios\CharuShankar.pdf' 'Charu Shankar' j=L link='Proceedings\Bios\IrvinSnider.pdf' 'Irvin Snider' j=L link='Proceedings\Bios\DougThompson.pdf' 'Doug Thompson (Volunteer)' j=L link='Proceedings\Bios\CatherineTruxillo.pdf' 'Catherine Truxillo' j=L link='Proceedings\Bios\CraigWildeman.pdf' 'Craig Wildeman (Volunteer)' j=L link='Proceedings\Bios\MichaelWilson.pdf' 'Michael Wilson' j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); *HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); %OtherPageImageAndFakeTable (BaseStyle=Styles.LeRBrecommended, WebPageBackgroundRGBcolor=CXFFFF99, ImageFile=susMap.gif); ods html path="&Path" (url=none) body='slides.html' (title="Slides for Wisconsin Illinois SAS Users Conference &MON &YEAR") style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize "Slides for Wisconsin Illinois SAS Users Conference &MON &YEAR"; title2 j=L ' ' j=L link='Proceedings\Slides\Bessler - Automate Highly Formatted Excel Reports Directly from SAS.pdf' 'Bessler - Automate Highly Formatted Excel Reports Directly from SAS' j=L link='Proceedings\Slides\Dickey - Finding the Gold in Your Data.pdf' 'Dickey - Finding the Gold in Your Data' j=L link='Proceedings\Slides\Dickey - Overview of Time Series and Forecasting.pdf' 'Dickey - Overview of Time Series and Forecasting' j=L link='Proceedings\Slides\Horstman - Let the CAT Out of the Bag - String Concatenation in SAS 9.pdf' 'Horstman - Let the CAT Out of the Bag - String Concatenation in SAS 9' j=L link="Proceedings\Slides\Horstman & Muller - Don't Let PROC COMPARE Catch You Unaware.pdf" "Horstman & Muller - Don't Let PROC COMPARE Catch You Unaware" j=L link='Proceedings\Slides\Hurley - Analysis of Count Data - A Business Perspective.pdf' 'Hurley - Analysis of Count Data - A Business Perspective' j=L link='Proceedings\Slides\Hurley - Underutilized Features in SAS Macro Language.pdf' 'Hurley - Underutilized Features in SAS Macro Language' j=L link='Proceedings\Slides\Johnson - Changing a Static Condition to a Dynamic Data-Driven Field with SAS.pdf' 'Johnson - Changing a Static Condition to a Dynamic Data-Driven Field with SAS' j=L link='Proceedings\Slides\Morrissey - SAS Visual Analytics.pdf' 'Morrissey - SAS Visual Analytics' j=L link='Proceedings\Slides\Shankar - Top 10 SAS Coding Efficiencies.pdf' 'Shankar - Top 10 SAS Coding Efficiencies' j=L link='Proceedings\Slides\Shankar - Why Choose Between SAS Data Step and PROC SQL When You Can Have Both.pdf' 'Shankar - Why Choose Between SAS Data Step and PROC SQL When You Can Have Both' j=L link='Proceedings\Slides\Snider - Credentials Randomization for Automated Email from SAS.pdf' 'Snider - Credentials Randomization for Automated Email from SAS' j=L link='Proceedings\Slides\Truxillo - Upscaling Your Mixed Models With the HPMIXED Procedure.pdf' 'Truxillo - Upscaling Your Mixed Models With the HPMIXED Procedure' j=L link='Proceedings\Slides\Truxillo - Which Proc Should I Learn First.pdf' "Truxillo - Which Proc Should I Learn First? A STAT Instructor's Top 5 Modeling Procedures" j=L link='Proceedings\Slides\Wilson - An Introduction to the Analysis of Failure-Time Data in Industrial Settings.pdf' 'Wilson - An Introduction to the Analysis of Failure-Time Data in Industrial Settings' j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); *HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); %OtherPageImageAndFakeTable (BaseStyle=Styles.LeRBrecommended, WebPageBackgroundRGBcolor=CXFFFF99, ImageFile=susMap.gif); ods html path="&Path" (url=none) body='papers.html' (title="Papers for Wisconsin Illinois SAS Users Conference &MON &YEAR") style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize "Papers for Wisconsin Illinois SAS Users Conference &MON &YEAR"; title2 j=L ' ' j=L link='Proceedings\Papers\Hurley - Analysis of Count Data A Business Perspective.pdf' 'Hurley - Analysis of Count Data - A Business Perspective' j=L link='Proceedings\Papers\Hurley - Underutilized Features in SAS Macro Language.pdf' 'Hurley - Underutilized Features in SAS Macro Language' j=L link='Proceedings\Papers\Johnson - Changing a Static Condition to a Dynamic Data-Driven Field with SAS.pdf' 'Johnson - Changing a Static Condition to a Dynamic Data-Driven Field with SAS' j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); %OtherPageImageAndFakeTable (BaseStyle=Styles.LeRBrecommended, WebPageBackgroundRGBcolor=CXFFFF99, ImageFile=susMap.gif); ods html path="&Path" (url=none) body='programs.html' (title='Sample SAS Programs') style=styles.LeRBrecommended; title1 j=L c=CX000000 h=&LargeFontSize 'Sample SAS Programs' j=L h=12 pt '(any data or macros used are SAS-provided, SoftwareUserServicesCD-provided, or created in the program)' j=L c=cx0000FF /*'NOTE: Programs have file extension .txt so that SAS will not be automatically launched upon Open.'*/ j=L ' '; title2 j=L c=CXFF0000 'If a link takes you to a folder, not a file, use the Back arrow, not the Up arrow, to get out,' j=L 'if you want to stay in the web front-end to these resources.' j=L 'The Up arrow will take you up the folder tree, and out of the web-linked environment.' j=L ' ' j=L link='Proceedings\Programs\Bessler - SAS with Excel DDE Tool Kit\' 'Bessler - SAS with Excel DDE Tool Kit' j=L link='Proceedings\Programs\Shankar - Top 10 SAS Coding Efficiencies\' 'Shankar - Top 10 SAS Coding Efficiencies' j=L link='Proceedings\Programs\Shankar - Why Choose Between SAS Data Step and PROC SQL When You Can Have Both\' 'Shankar - Why Choose Between SAS Data Step and PROC SQL When You Can Have Both' j=L link='Proceedings\Programs\Truxillo - Upscaling Your Mixed Models With the HPMIXED Procedure.txt' 'Truxillo - Upscaling Your Mixed Models With the HPMIXED Procedure' j=L link='Proceedings\Programs\Truxillo - Which Proc Should I Learn First.txt' "Truxillo - Which Proc Should I Learn First? A STAT Instructor's Top 5 Modeling Procedures" j=L link='Proceedings\Programs\SUS_WebPubPgm_SAScode.txt' "SUS_WebPubPgm (used to created these web pages for the SUS &MON &YEAR Proceedings)" j=L ' ' j=L link='StartHere.html' 'Home Page'; %WebPubStdFootNote(Year=&YEAR,FtNumber=1,WebPageBackgroundRGBcolor=&WebPageBackground); *HiddenFakeTable(BaseStyle=LeRBrecommended,WebPageBackgroundRGBcolor=&WebPageBackground); %OtherPageImageAndFakeTable (BaseStyle=Styles.LeRBrecommended, WebPageBackgroundRGBcolor=CXFFFF99, ImageFile=susMap.gif); ods html close; ods listing;